<?php

namespace App\Http\Controllers\admin;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\SuperRole;
use App\Models\AdminSuperRoles;
use Illuminate\Support\Facades\Validator;

use Yajra\DataTables\Facades\DataTables;
use App\Models\Admin;

use Illuminate\Validation\Rule;
use Illuminate\Support\Facades\DB;


class StaffController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(Request $request)
    {

        if ($request->ajax()) {
            $search_keyword = '';
            $status = 'all'; // all status
            $start_date = '';
            $end_date = '';
            $request_data = $request->all();
            if ($request->has('search_keyword')) {
                $search_keyword = $request->search_keyword;
            }
            if ($request->has('status_filter')) {
                $status = $request->status_filter;
            }
            // avoid zero column as it's checkbox so we can't sort by it
            if ($request->has('order') && $request->order[0]['column'] != 0) {
                $sort_column_number = $request->order[0]['column'];
                $sort_column_dir = $request->order[0]['dir'];
                $sort_column_key = $request->columns[$sort_column_number]['data'];
            }
            if ($request->has('date_range_filter') && $request->date_range_filter != '') {
                $date_range_filter_arr = explode(' - ', $request->date_range_filter);
                $start_date = formatDate($date_range_filter_arr[0]);
                $end_date = formatDate($date_range_filter_arr[1]);
            }

            $main_query = Admin::query();
            $query = $main_query;
            if (!empty($search_keyword)) {
                $query = $query->where('first_name', 'LIKE', '%' . $search_keyword . '%')->orWhere('last_name', 'LIKE', '%' . $search_keyword . '%');
            }
            if ($status != 'all' && $status != '') {
                $query = $query->where('status', $status);
            }
            if (!empty($sort_column_key)) {
                $query = $query->orderBy($sort_column_key, $sort_column_dir);
            } else {
                $query = $query->latest();
            }
            if ($start_date != '' && $end_date != '') {
                $query = $query->whereDate('created_at', '>=', $start_date)->whereDate('created_at', '<=', $end_date);
            }

            $data = $query->with('adminSuperRoles');
            $data = $query->get();

            $count_total = $main_query->count();
            $count_filter = $count_total;
            return DataTables::of($data)

                ->addColumn('first_name', function ($row) {
                    return $row->first_name . ' ' . $row->last_name;
                })
                ->addColumn('email', function ($row) {
                    return $row->email;
                })
                ->editColumn('status', function ($row) {
                    $update_url = route('admin.update.staff.status', $row->id);
                    return setStatus($row, $update_url);
                })

                ->addColumn('role', function ($row) {
                    $roleNames = '';
                    if (isset($row->adminSuperRoles) && isset($row->adminSuperRoles->role)) {
                        // foreach ($row->adminSuperRoles as $adminSuperRole) {
                        //     if ($adminSuperRole->role) {
                        //         $roleNames .= $adminSuperRole->role->name . ' ';
                        //     }
                        // }
                        $roleNames = $row->adminSuperRoles->role->name;
                    }
                    return $roleNames;
                })


                ->editColumn('created_at', function ($row) {
                    return formatDate($row->created_at);
                })
                ->addColumn('action', function ($row) {

                    if ($row->is_super !== 1) {

                        return view('admin.staff.partially.delete', compact('row'));
                    }
                })
                ->rawColumns(['action', 'status'])
                ->with([
                    "recordsTotal"    => $count_total,
                    "recordsFiltered" => $count_filter,
                ])
                ->make(true);
        }
        return view('admin.staff.index');
    }

    /**
     * Show the form for creating a new resource.
     */
    public function create()
    {
        $roles = SuperRole::all();

        return view('admin.staff.create', compact('roles'));
    }

    /**
     * Store a newly created resource in storage.
     */
    public function store(Request $request)
    {

        $validator = Validator::make($request->all(), [
            'first_name' => 'required',
            'last_name' => 'required',
            'email' => 'required|string|lowercase|email|max:255|unique:admins',
            'password' => 'required|string|min:8|confirmed',
            'role_id' => 'required|exists:super_roles,id',


        ]);
        if ($validator->fails()) {
            return redirect()->back()->withErrors($validator)->withInput();
        }
        DB::beginTransaction();
        try {
            $admin_staff = new Admin();
            $admin_staff->first_name = $request->first_name;
            $admin_staff->last_name = $request->last_name;
            $admin_staff->status = $request->has('is_active') ? 1 : 0;
            $admin_staff->email = $request->email;
            $admin_staff->password = bcrypt($request->password);
            $admin_staff->save();

            $adminRole = new AdminSuperRoles();
            $adminRole->role_id = $request->role_id;
            $adminRole->admin_id = $admin_staff->id;
            $adminRole->save();
            DB::commit();

            return redirect()->route('staff.index')->with('success', 'Admin Staff has been added successfully.');
        } catch (\Exception $e) {
            DB::rollback();
            return response()->json(['success' => false, 'message' => $e->getMessage()]);
        }
    }

    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        $admin_staff = Admin::with('adminSuperRoles')->find($id);
        $roles = SuperRole::all();
        if (isset($admin_staff)) {
            return view('admin.staff.edit', ['admin_staff' => $admin_staff, 'roles' => $roles]);
        } else {
            return back()->with('error', 'Admin Staff does not exist');
        }
    }

    /**
     * Update the specified resource in storage.
     */
    public function update(Request $request, string $id)
    {
        $validator = Validator::make($request->all(), [
            'first_name' => 'required',
            'last_name' => 'required',
            'email' => ['required', 'string', 'lowercase', 'email', 'max:255',  Rule::unique('admins')->ignore($id)],
            'role_id' => 'required|exists:super_roles,id',
        ]);

        if ($validator->fails()) {
            return redirect()->back()->withErrors($validator)->withInput();
        }

        DB::beginTransaction();
        try {

            $admin_staff = Admin::find($id);
            $admin_staff->first_name = $request->input('first_name');
            $admin_staff->last_name = $request->input('last_name');
            $admin_staff->status = $request->has('is_active') ? 1 : 0;
            $admin_staff->email = $request->input('email');
            $admin_staff->save();

            $adminSuperRole = AdminSuperRoles::where('admin_id', $id)->first();
            $adminSuperRole->role_id = $request->role_id;
            $adminSuperRole->save();
            DB::commit();
            return redirect()->route('staff.index')->with('success', 'Admin Staff has been updated successfully');
        } catch (\Exception $e) {
            DB::rollback();
            return response()->json(['success' => false, 'message' => $e->getMessage()]);
        }
    }


    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
        $admin_staff = Admin::find($id);
        if (isset($admin_staff)) {
            $admin_staff->forceDelete();
            $adminSuperRole = AdminSuperRoles::where('admin_id', $id)->delete();
            return redirect()->back()->with('success', 'Admin Staff has been deleted successfully.');
        } else {
            return back()->with('error', 'Staff not found.');
        }
    }
    public function updateAdminStaffStatus(Request $request, $id)
    {
        if ($request->has('new_status')) {
            $staff = Admin::find($id);

            if ($staff) {
                $staff->status = $request->new_status;
                $staff->save();
                return response()->json(['status' => 'success', 'message' => 'Admin Staff status updated successfully']);
            } else {
                return response()->json(['status' => 'error', 'message' => 'Admin Staff not found'], 404);
            }
        } else {
            return response()->json(['status' => 'error', 'message' => 'Missing status value'], 404);
        }
    }
}